Skip Headers

Oracle® OLAP Reference 10g Release 2 (10.2) Part Number B14350-01 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# ALL_OLAP2_CUBE_MEAS_DIM_USES

`ALL_OLAP2_CUBE_MEAS_DIM_USES` shows how each measure is aggregated along each of its dimensions. The default aggregation method is addition.

Column | Data Type | NULL | Description
--- | --- | --- | ---
`OWNER` | `VARCHAR2(30)` | `NOT NULL` | Owner of the cube that contains this measure.
`CUBE_NAME` | `VARCHAR2(30)` | `NOT NULL` | Name of the cube that contain this measure.
`MEASURE_NAME` | `VARCHAR2(30)` | `NOT NULL` | Name of the measure.
`DIMENSION_OWNER` | `VARCHAR2(30)` | `NOT NULL` | Owner of a dimension associated with this measure.
`DIMENSION_NAME` | `VARCHAR2(30)` | `NOT NULL` | Name of the dimension.
`DIMENSION_ALIAS` | `VARCHAR2(30)` |  | Alias of the dimension.
`DEFAULT_AGGR_FUNCTION_USE_ID` | `NUMBER` |  | The default aggregation method used to aggregate this measure's data over this dimension. If this column is null, the aggregation method is addition.